# crawler/models.py
from django.db import models
import django.utils.timezone as timezone


class Job(models.Model):

	id = models.AutoField(primary_key=True, editable=False)
	job_name = models.CharField(verbose_name='名称',null=True,max_length=255)
	requirement = models.CharField(verbose_name='要求',null=True,max_length=255)
	job_city = models.CharField(verbose_name='工作城市',null=True,max_length=50)
	job_place = models.CharField(verbose_name='工作地点',null=True,max_length=50)
	job_experience = models.CharField(verbose_name='工作经验',null=True,max_length=50)
	job_education = models.CharField(verbose_name='学历要求',null=True,max_length=50)
	min_wage = models.CharField(verbose_name='最低薪资',null=True,max_length=50)
	max_wage = models.CharField(verbose_name='最高薪资',null=True,max_length=50)
	final_wage = models.CharField(verbose_name='年终薪资',null=True,max_length=50)
	company_name = models.CharField(verbose_name='公司名称',null=True,max_length=255)
	company_industry = models.CharField(verbose_name='公司行业',null=True,max_length=255)
	number_of_company_personnel = models.CharField(verbose_name='公司人数',null=True,max_length=255)

	class Meta:
		verbose_name = '静态爬虫工作信息表'
		verbose_name_plural = verbose_name


class JobSele(models.Model):

	id = models.AutoField(primary_key=True, editable=False)
	job_name = models.CharField(verbose_name='名称',null=True,max_length=50)
	job_city = models.CharField(verbose_name='工作城市',null=True,max_length=50)
	job_place = models.CharField(verbose_name='工作地点',null=True,max_length=50)
	job_experience = models.CharField(verbose_name='工作经验',null=True,max_length=50)
	job_education = models.CharField(verbose_name='学历要求',null=True,max_length=50)
	min_wage = models.CharField(verbose_name='最低薪资',null=True,max_length=50)
	max_wage = models.CharField(verbose_name='最高薪资',null=True,max_length=50)
	final_wage = models.CharField(verbose_name='年终薪资',null=True,max_length=50)
	job_benefits = models.CharField(verbose_name='公司福利',null=True,max_length=255)
	update_time = models.CharField(verbose_name='日期',null=True,max_length=255)
	company_name = models.CharField(verbose_name='公司名称',null=True,max_length=50)
	financing = models.CharField(verbose_name='融资状况',null=True,max_length=50)

	class Meta:
		verbose_name = '动态爬虫工作信息表'
		verbose_name_plural = verbose_name